﻿CREATE TABLE [dbo].[users] (
    [user_id]              BIGINT         IDENTITY (1, 1) NOT NULL,
    [username]             NVARCHAR (255) NULL,
    [email]                NVARCHAR (255) NULL,
    [windowslivetoken]     NVARCHAR (255) NULL,
    [locked]               BIT            NULL,
    [first_name]           NVARCHAR (255) NULL,
    [last_name]            NVARCHAR (255) NULL,
    [description]          NVARCHAR (255) NULL,
    [homepage]             NVARCHAR (255) NULL,
    [address]              NVARCHAR (255) NULL,
    [phone]                NVARCHAR (255) NULL,
    [school]               NVARCHAR (255) NULL,
    [field_of_study]       NVARCHAR (255) NULL,
    [company]              NVARCHAR (255) NULL,
    [job_title]            NVARCHAR (255) NULL,
    [send_events_mails]    BIT            NULL,
    [send_community_mails] BIT            NULL,
    [show_first_name]      BIT            NULL,
    [show_last_name]       BIT            NULL,
    [show_address]         BIT            NULL,
    [show_job_title]       BIT            NULL,
    [show_email]           BIT            NULL,
    [show_field_of_study]  BIT            NULL,
    [show_company]         BIT            NULL,
    [show_school]          BIT            NULL,
    [show_phone]           BIT            NULL,
    [created]              DATETIME       NULL,
    [modified]             DATETIME       NULL,
    PRIMARY KEY CLUSTERED ([user_id] ASC)
);

